﻿	CREATE TABLE public.account_role
	(
	    /***************************************************************************************************
	    **  Table:	    public.account_role
	    **  Author:		Zhixian Ong
	    **
	    **  Description:
	    **    
	    **    List of registered account role.
        **    Mapping roles to accounts
	    **
	    **  Fields (2):
	    **
	    **      account_id  -
	    **      role_id     -
	    **
	    **  Constaints (1):
	    **
	    **      account_role_pk - 
	    **      
	    **
	    **  Modification History:
	    **
	    **      20140102  Zhixian Ong     - Initial prototype
	    ** 
	    **  Status:
	    **
	    **      Dev
	    ** 
	    ***************************************************************************************************/
        
	    -- [Fields]
	    account_id  integer                 NOT NULL,
	    role_id     integer                 NOT NULL,
        
	    -- [Constraints]
	    CONSTRAINT account_role_pk PRIMARY KEY (account_id, role_id)
	);
	